How to: Copy a range in a worksheet.
Solution:
Select the range to be copied. Copy and paste the range into the new location.
1) Select the range to be copied. (The cells within the range are highlighted.)
2) Select the 'Edit' menu and select 'Copy'.
3) Select the upper-left cell where the range is to be pasted.
4) Select the 'Edit' menu and select 'Paste'.